{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":40,"n_cols":10,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[null,"Exercício 5.5 - Simulação"]
[]
[]
[null,"P(AvMotor/AvMotor)",null,null,0.17]
[null,"P(AvProg/AvProg)",null,null,0.5]
[]
[null,"Nº","Tipo",null,"Próxima ","      Custo","Reparação","        Nº Avarias"]
[null,"Avaria","Avaria","NPA","Avaria","Avaria","Acumulado","Motor","Programador"]
[null,0,"Motor",{"$f":"RAND()","v":0.74482173162437171},{"$f":"IF(C9=\"Motor\",IF(D9<$E$4,\"Motor\",\"Programador\"),IF(D9<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},0,{"$f":"+F9","v":0},0,0]
[null,{"$f":"+B9+1","v":1},{"$f":"+E9","v":"Programador"},{"$f":"RAND()","v":0.78929151734899017},{"$f":"IF(C10=\"Motor\",IF(D10<$E$4,\"Motor\",\"Programador\"),IF(D10<$E$5,\"Programador\",\"Motor\"))","v":"Motor"},{"$f":"IF(C9=\"Motor\",IF(C10=\"Motor\",0,20),IF(C10=\"Programador\",0,55))","v":20},{"$f":"+G9+F10","v":20},{"$f":"IF(C10=\"Motor\",H9+1,H9)","v":0},{"$f":"IF(C10=\"Motor\",I9,I9+1)","v":1},{"$f":"IF(F10=0,1,0)","v":0}]
[null,{"$f":"+B10+1","v":2},{"$f":"+E10","v":"Motor"},0.77374891033693105,"Programador",{"$f":"IF(C10=\"Motor\",IF(C11=\"Motor\",0,20),IF(C11=\"Programador\",0,55))","v":55},{"$f":"+G10+F11","v":75},{"$f":"IF(C11=\"Motor\",H10+1,H10)","v":1},{"$f":"IF(C11=\"Motor\",I10,I10+1)","v":1},{"$f":"IF(F11=0,1,0)","v":0}]
[null,3,"Programador",0.65977096147274739,"Motor",{"$f":"IF(C11=\"Motor\",IF(C12=\"Motor\",0,20),IF(C12=\"Programador\",0,55))","v":20},95,1,2,0]
[null,4,"Motor",0.95658969783185543,"Programador",55,150,2,2,0]
[null,5,"Programador",0.36047072739411812,"Programador",20,170,2,3,0]
[null,6,"Programador",0.98658292998858832,"Motor",0,170,2,4,1]
[null,7,"Motor",0.76625579473676075,"Programador",55,225,3,4,0]
[null,8,"Programador",0.6341873504936193,"Motor",20,245,3,5,0]
[null,9,"Motor",0.60108724400939206,"Programador",55,300,4,5,0]
[null,10,"Programador",0.60097646436172536,"Motor",20,320,4,6,0]
[null,11,"Motor",0.25836975960952868,"Programador",55,375,5,6,0]
[null,12,"Programador",0.95338481989660262,"Motor",20,395,5,7,0]
[null,13,"Motor",0.52573682872059257,"Programador",55,450,6,7,0]
[null,14,"Programador",0.15287162951310029,"Programador",20,470,6,8,0]
[null,15,"Programador",0.94162542018130335,"Motor",0,470,6,9,1]
[null,{"$f":"+B24+1","v":16},{"$f":"+E24","v":"Motor"},0.91251256147401327,{"$f":"IF(C25=\"Motor\",IF(D25<$E$4,\"Motor\",\"Programador\"),IF(D25<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},{"$f":"IF(C24=\"Motor\",IF(C25=\"Motor\",0,20),IF(C25=\"Programador\",0,55))","v":55},525,{"$f":"IF(C25=\"Motor\",H24+1,H24)","v":7},{"$f":"IF(C25=\"Motor\",I24,I24+1)","v":9},0]
[null,{"$f":"+B25+1","v":17},{"$f":"+E25","v":"Programador"},0.29133041977305385,{"$f":"IF(C26=\"Motor\",IF(D26<$E$4,\"Motor\",\"Programador\"),IF(D26<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},{"$f":"IF(C25=\"Motor\",IF(C26=\"Motor\",0,20),IF(C26=\"Programador\",0,55))","v":20},545,{"$f":"IF(C26=\"Motor\",H25+1,H25)","v":7},{"$f":"IF(C26=\"Motor\",I25,I25+1)","v":10},0]
[null,{"$f":"+B26+1","v":18},{"$f":"+E26","v":"Programador"},9.4596241486834765E-2,{"$f":"IF(C27=\"Motor\",IF(D27<$E$4,\"Motor\",\"Programador\"),IF(D27<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},{"$f":"IF(C26=\"Motor\",IF(C27=\"Motor\",0,20),IF(C27=\"Programador\",0,55))","v":0},545,{"$f":"IF(C27=\"Motor\",H26+1,H26)","v":7},{"$f":"IF(C27=\"Motor\",I26,I26+1)","v":11},1]
[null,{"$f":"+B27+1","v":19},{"$f":"+E27","v":"Programador"},0.19295546755905169,{"$f":"IF(C28=\"Motor\",IF(D28<$E$4,\"Motor\",\"Programador\"),IF(D28<$E$5,\"Programador\",\"Motor\"))","v":"Programador"},{"$f":"IF(C27=\"Motor\",IF(C28=\"Motor\",0,20),IF(C28=\"Programador\",0,55))","v":0},545,{"$f":"IF(C28=\"Motor\",H27+1,H27)","v":7},{"$f":"IF(C28=\"Motor\",I27,I27+1)","v":12},1]
[null,{"$f":"+B28+1","v":20},{"$f":"+E28","v":"Programador"},0.54282686585564799,{"$f":"IF(C29=\"Motor\",IF(D29<$E$4,\"Motor\",\"Programador\"),IF(D29<$E$5,\"Programador\",\"Motor\"))","v":"Motor"},{"$f":"IF(C28=\"Motor\",IF(C29=\"Motor\",0,20),IF(C29=\"Programador\",0,55))","v":0},545,{"$f":"IF(C29=\"Motor\",H28+1,H28)","v":7},{"$f":"IF(C29=\"Motor\",I28,I28+1)","v":13},1]
[]
[]
[null,null,null,"Medidas de Performance"]
[]
[null,null,"% Reparações gratuitas",null,null,{"$f":"SUM(J10:J29)/MAX(B9:B29)*100","v":25},"%"]
[]
[null,null,"% Avarias no Motor",null,null,{"$f":"+MAX(H9:H29)/MAX(B9:B29)*100","v":35},"%"]
[]
[null,null,"% Avarias no Programador",null,null,{"$f":"MAX(I9:I29)/MAX(B9:B29)*100","v":65},"%"]
[]
[null,null,"Custo médio por avaria",null,null,{"$f":"MAX(G9:G29)/MAX(B9:B29)","v":27.25},"u.m."]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}